-------------------------------------------------------------
--					Add Procedure
-------------------------------------------------------------
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Customers_CheckCustomersByName]') AND type in (N'P', N'PC'))
BEGIN
DROP PROCEDURE [Customers_CheckCustomersByName]
END
GO

Create Procedure [dbo].[Customers_CheckCustomersByName]
(
	@CustomerName nvarchar(max)
)
AS

	SELECT * from dbo.Customers 
	where ISDELETED=0 
	and CustomerName = @CustomerName